Item Class Setup (IV40400)

SELECT
       ['Item Class Setup'].NOTEINDX AS 'Item Class Setup-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       IV40400 AS ['Item Class Setup']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Item Class Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX

1	0 decimals
2	1
3	2
4	3
5	4
6	5

SELECT
       ['Item Class Setup'].ITMTSHID AS 'Item Class Setup-Item Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       IV40400 AS ['Item Class Setup']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Item Class Setup'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID

SELECT
       ['Item Class Setup'].Purchase_Item_Tax_Schedu AS 'Item Class Setup-Purchase Item Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       IV40400 AS ['Item Class Setup']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Item Class Setup'].Purchase_Item_Tax_Schedu = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID

SELECT
       ['Item Class Setup'].UOMSCHDL AS 'Item Class Setup-U Of M Schedule'
       ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
       IV40400 AS ['Item Class Setup']
INNER JOIN
       IV40201 AS ['Inventory U of M Schedule Setup']
              ON
                     ['Item Class Setup'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL

1	FIFO Perpetual
2	LIFO Perpetual
3	Average Perpetual
4	FIFO Periodic
5	LIFO Periodic

SELECT
       ['Item Class Setup'].IVIVINDX AS 'Item Class Setup-IV IV Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV40400 AS ['Item Class Setup']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Class Setup'].IVIVINDX = ['Account Index Master'].ACTINDX

SELECT
       ['Item Class Setup'].IVIVOFIX AS 'Item Class Setup-IV IV Offset Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV40400 AS ['Item Class Setup']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Class Setup'].IVIVOFIX = ['Account Index Master'].ACTINDX

SELECT
       ['Item Class Setup'].IVCOGSIX AS 'Item Class Setup-IV COGS Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV40400 AS ['Item Class Setup']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Class Setup'].IVCOGSIX = ['Account Index Master'].ACTINDX

SELECT
       ['Item Class Setup'].IVSLSIDX AS 'Item Class Setup-IV Sales Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV40400 AS ['Item Class Setup']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Class Setup'].IVSLSIDX = ['Account Index Master'].ACTINDX

SELECT
       ['Item Class Setup'].IVSLDSIX AS 'Item Class Setup-IV Sales Discounts Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV40400 AS ['Item Class Setup']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Class Setup'].IVSLDSIX = ['Account Index Master'].ACTINDX

SELECT
       ['Item Class Setup'].IVSLRNIX AS 'Item Class Setup-IV Sales Returns Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV40400 AS ['Item Class Setup']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Class Setup'].IVSLRNIX = ['Account Index Master'].ACTINDX

SELECT
       ['Item Class Setup'].IVINUSIX AS 'Item Class Setup-IV In Use Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV40400 AS ['Item Class Setup']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Class Setup'].IVINUSIX = ['Account Index Master'].ACTINDX

SELECT
       ['Item Class Setup'].IVINSVIX AS 'Item Class Setup-IV In Service Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV40400 AS ['Item Class Setup']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Class Setup'].IVINSVIX = ['Account Index Master'].ACTINDX

SELECT
       ['Item Class Setup'].IVDMGIDX AS 'Item Class Setup-IV Damaged Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV40400 AS ['Item Class Setup']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Class Setup'].IVDMGIDX = ['Account Index Master'].ACTINDX

SELECT
       ['Item Class Setup'].IVVARIDX AS 'Item Class Setup-IV Variances Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV40400 AS ['Item Class Setup']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Class Setup'].IVVARIDX = ['Account Index Master'].ACTINDX

SELECT
       ['Item Class Setup'].DPSHPIDX AS 'Item Class Setup-Drop Ship Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV40400 AS ['Item Class Setup']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Class Setup'].DPSHPIDX = ['Account Index Master'].ACTINDX

SELECT
       ['Item Class Setup'].PURPVIDX AS 'Item Class Setup-Purchase Price Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV40400 AS ['Item Class Setup']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Class Setup'].PURPVIDX = ['Account Index Master'].ACTINDX

SELECT
       ['Item Class Setup'].UPPVIDX AS 'Item Class Setup-Unrealized Purchase Price Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV40400 AS ['Item Class Setup']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Class Setup'].UPPVIDX = ['Account Index Master'].ACTINDX

SELECT
       ['Item Class Setup'].IVRETIDX AS 'Item Class Setup-Inventory Returns Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV40400 AS ['Item Class Setup']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Class Setup'].IVRETIDX = ['Account Index Master'].ACTINDX

SELECT
       ['Item Class Setup'].ASMVRIDX AS 'Item Class Setup-Assembly Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV40400 AS ['Item Class Setup']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Class Setup'].ASMVRIDX = ['Account Index Master'].ACTINDX

SELECT
       ['Item Class Setup'].IVSCRVIX AS 'Item Class Setup-IV STD Cost Revaluation Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV40400 AS ['Item Class Setup']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Class Setup'].IVSCRVIX = ['Account Index Master'].ACTINDX